import pandas as pd
from pyecharts import options as opts
from pyecharts.charts import Line
from pyecharts.globals import ThemeType

df = pd.read_excel('全国居民人均可支配收入季度数据.xlsx', index_col=0)
df = df.iloc[:, ::-1]

line = Line(init_opts=opts.InitOpts(width='800px', height='400px', theme=ThemeType.INFOGRAPHIC, page_title='面积图'))
line.add_xaxis(xaxis_data=['第一季度', '第二季度', '第三季度', '第四季度'])
line.add_yaxis(series_name='2020 年', y_axis=df.iloc[0, 0:4], areastyle_opts=opts.AreaStyleOpts(opacity=0.5))
line.add_yaxis(series_name='2021 年', y_axis=df.iloc[0, 4:8], areastyle_opts=opts.AreaStyleOpts(opacity=0.5))
line.add_yaxis(series_name='2022 年', y_axis=df.iloc[0, 8:12], areastyle_opts=opts.AreaStyleOpts(opacity=0.5))

line.set_global_opts(
    title_opts=opts.TitleOpts(title='2020—2022 年每年各季度全国居民人均可支配收入面积图', pos_left='center'),
    yaxis_opts=opts.AxisOpts(name='全国居民人均可支配收入（元）', name_location='center', name_gap=55),
    legend_opts=opts.LegendOpts(pos_right='10%', pos_top='8%')
)

line.render('例 7-2.html')